1 1. Intoduction
1.0.0.1 We have 12 datasets, 4 categories (DataClin, CRO, MA, and SMO), Each category has 3 datasets (Visitors, Followers, Content)
- Visitors’ datasets provide insights about people who visit any of DataClin LinkedIn pages in a detailed way as follows
number of people visited the page using mobile/ desktop and total of them
number of people visited the life/ Jobs pages
unique number of visitors (may differ from the total number as this column removes duplicate visitors)
There are 5 sheets in the dataset, each sheet aggregates the data according to a different variable of the below:
Location
Seniority (titles of people who visited the pages)
Job functions
Industry
Company size
- Visitors’ datasets provide insights about people who visit any of DataClin LinkedIn pages in a detailed way as follows
- Followers’ datasets provide insights about followers of any DataClin LinkedIn pages in a detailed way as follows
number of organic followers (followers of genuine interest without any paid promotions)
number of sponsored followers (though ads)
auto-invitations (Premium feature that sends invitation automatically to LinkedIn users to follow DataClin pages)
There are 5 sheets in the dataset, each sheet aggregates the data according to a different variable of the below:
Location
Seniority (titles of people who visited the pages)
Job functions
Industry
Company size
- Followers’ datasets provide insights about followers of any DataClin LinkedIn pages in a detailed way as follows
- Content’s datasets provide insights about the content of any DataClin LinkedIn pages in a detailed way as follows
number of impressions (how many times the post has been shown to people on LinkedIn), clicks (how many unique clicks on the post), reactions, comments, reposts, and engagement rates (which = total number of interactions + Clicks + followers/ number of impressions)
the sheet called “All posts” collects posts shared on LinkedIn with their dates, who posted them, impressions, views, clicks, interactions, and engagement rate
the click through rate (CTR): (number of clicks/ number of impressions) – The rate of people who see the posts and click on them
- Content’s datasets provide insights about the content of any DataClin LinkedIn pages in a detailed way as follows
2 2. Questions
- Is there a statistically significant trend for each page when comparing month-over-month data in:
total impressions
Total unique impressions
Total clicks
Total reactions
Total comments
Total reposts
Total engagement rate
- Which page has the best total unique impressions overall?
- Which page has the best average unique impressions overall?
- Are there any specific metrics where one employee consistently achieves higher counts than the other?
- Is there a statistically significant trend for each page when comparing month-over-month data in:
3 3. Exploratory Data Analysis
Q1: Is there a statistically significant trend for each page when comparing month-over-month data in:
total impressions
Total unique impressions
Total clicks
Total reactions
Total comments
Total reposts
Total engagement rate
Q2 :Which page has the best total unique impressions overall?
Q3: Which page has the best average unique impressions overall?
Q4: Are there any specific metrics where one employee consistently achieves higher counts than the other?